--------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\wb614536\Downloads\replication\replication\code\../outputs/14_DescHistograms_log.txt
  log type:  text
 opened on:  25 Jun 2026, 13:03:33
r; t=0.00 13:03:33

. 
. include "_OutcomeLabels.do"

. /*==============================================================================
>   _OutcomeLabels.do  (helper, not run on its own)
> 
>   Defines polished, publication-ready labels for every outcome that appears
>   in figures and tables. Labels use the macro pattern `lbl_<outcome>`.
>   Visualization do files `include` this file and reference `lbl_<outcome>`
>   to print a pretty label rather than the raw Stata variable name.
> 
>   Categorical/binary indicators are suffixed with "[=1]" so the reader sees
>   what a unit change means; counts and continuous variables get explicit
>   units; standardized indices are flagged "(SD)".
> 
>   Sandra Rozo
> ==============================================================================*/
. 
. * ---- Economic well-being -----------------------------------------------------
. local lbl_jeea_index_wellbeing  "Well-being index (SD)"
r; t=0.00 13:03:33

. local lbl_labour_income         "Log monthly labor income"
r; t=0.00 13:03:33

. local lbl_gasto_capita          "Log per-capita HH consumption"
r; t=0.00 13:03:33

. local lbl_income_maxhh          "Log HH-max labor income"
r; t=0.00 13:03:33

. local lbl_employed              "Employed [=1]"
r; t=0.00 13:03:33

. 
. * ---- Labor ------------------------------------------------------------------
. local lbl_jeea_index_labor      "Labor index (SD)"
r; t=0.00 13:03:33

. local lbl_formal                "Formal employment [=1]"
r; t=0.00 13:03:33

. local lbl_hora_semana           "Log weekly hours (salaried)"
r; t=0.00 13:03:33

. 
. * ---- Services and rights ----------------------------------------------------
. local lbl_jeea_index_services   "Services index (SD)"
r; t=0.00 13:03:33

. local lbl_sisben                "SISBEN registration [=1]"
r; t=0.00 13:03:33

. local lbl_subs                  "Subsidized health [=1]"
r; t=0.00 13:03:33

. local lbl_bank                  "Savings account [=1]"
r; t=0.00 13:03:33

. local lbl_has_bank_account      "Bank account (incl. savings) [=1]"
r; t=0.00 13:03:33

. local lbl_govtr                 "Govt. transfers [=1]"
r; t=0.00 13:03:33

. 
. * ---- Health -----------------------------------------------------------------
. local lbl_health_pca            "Health PCA index (SD)"
r; t=0.00 13:03:33

. local lbl_anx_depr              "Severe anxiety/depression [=1]"
r; t=0.00 13:03:33

. local lbl_any_anx_depr          "Any anxiety/depression [=1]"
r; t=0.00 13:03:33

. local lbl_vas_score             "Self-rated health (0-100)"
r; t=0.00 13:03:33

. local lbl_phys_problem          "Physical health problem [=1]"
r; t=0.00 13:03:33

. local lbl_chronic_illness       "Chronic illness [=1]"
r; t=0.00 13:03:33

. local lbl_mh_index              "Mental-health composite (SD)"
r; t=0.00 13:03:33

. local lbl_life_satisfaction     "Life satisfaction (0-10)"
r; t=0.00 13:03:33

. local lbl_hi5_inv               "EQ-5D anx/depr (5-low to 1-high)"
r; t=0.00 13:03:33

. 
. * ---- Food security ----------------------------------------------------------
. local lbl_index_food            "Food security index (SD)"
r; t=0.00 13:03:33

. local lbl_skip_meals            "Skipped meals last month [=1]"
r; t=0.00 13:03:33

. local lbl_went_without_food     "Went without food [=1]"
r; t=0.00 13:03:33

. local lbl_protein_days          "Days w/ protein (last week)"
r; t=0.00 13:03:33

. local lbl_food_insecure_seek    "Sought food assistance [=1]"
r; t=0.00 13:03:33

. 
. * ---- Housing ----------------------------------------------------------------
. local lbl_index_housing         "Housing quality index (SD)"
r; t=0.00 13:03:33

. local lbl_adequate_housing      "Adequate housing [=1]"
r; t=0.00 13:03:33

. local lbl_has_electricity       "Has electricity [=1]"
r; t=0.00 13:03:33

. local lbl_has_water             "Has running water [=1]"
r; t=0.00 13:03:33

. local lbl_has_sewage            "Has sewage [=1]"
r; t=0.00 13:03:33

. 
. * ---- Integration ------------------------------------------------------------
. local lbl_index_integration     "Integration index (SD)"
r; t=0.00 13:03:33

. local lbl_belonging             "Sense of belonging (1-4)"
r; t=0.00 13:03:33

. local lbl_feel_integrated       "Feels integrated (1-4)"
r; t=0.00 13:03:33

. local lbl_trust_col             "Trust in Colombians (out-group, 1-5)"
r; t=0.00 13:03:33

. local lbl_trust_ven             "Trust in Venezuelans (in-group, 1-5)"
r; t=0.00 13:03:33

. local lbl_general_trust         "General trust in people (1-5)"
r; t=0.00 13:03:33

. local lbl_venezuelans_help_me   "Venezuelans help me (1-5)"
r; t=0.00 13:03:33

. local lbl_trust_index           "Prosocial behaviors composite (SD)"
r; t=0.00 13:03:33

. local lbl_col_friends           "Number Colombian friends"
r; t=0.00 13:03:33

. local lbl_community_org         "Belongs to community org [=1]"
r; t=0.00 13:03:33

. local lbl_connection_colombia   "Strong connection to Colombia [=1]"
r; t=0.00 13:03:33

. local lbl_colombians_help_me    "Colombians help me (1-5)"
r; t=0.00 13:03:33

. local lbl_count_on_col          "Can count on Colombians (1-5)"
r; t=0.00 13:03:33

. 
. * ---- Discrimination ---------------------------------------------------------
. local lbl_index_discrim         "Discrimination index (SD)"
r; t=0.00 13:03:33

. local lbl_discrim_ever          "Ever discriminated against [=1]"
r; t=0.00 13:03:33

. local lbl_discrim_freq          "Discrimination frequency (1-5)"
r; t=0.00 13:03:33

. local lbl_filed_complaint       "Filed discrimination complaint [=1]"
r; t=0.00 13:03:33

. 
. * ---- Migration intentions ---------------------------------------------------
. local lbl_intend_stay           "Intends to stay in Colombia [=1]"
r; t=0.00 13:03:33

. local lbl_plan_stay_5yr         "Plans to stay 5+ years [=1]"
r; t=0.00 13:03:33

. local lbl_considered_return_ven "Considered returning to Venezuela [=1]"
r; t=0.00 13:03:33

. 
. * ---- COVID -----------------------------------------------------------------
. local lbl_index_covid           "COVID resilience index (SD)"
r; t=0.00 13:03:33

. local lbl_covid_income_down     "Income fell during COVID [=1]"
r; t=0.00 13:03:33

. local lbl_covid_eviction        "Faced eviction during COVID [=1]"
r; t=0.00 13:03:33

. local lbl_covid_received_aid    "Received COVID aid [=1]"
r; t=0.00 13:03:33

. 
. * ---- Education -------------------------------------------------------------
. local lbl_currently_studying    "Currently studying [=1]"
r; t=0.00 13:03:33

. local lbl_currently_enrolled    "Currently enrolled in school [=1]"
r; t=0.00 13:03:33

. local lbl_degree_validated      "Foreign degree validated [=1]"
r; t=0.00 13:03:33

. 
. * ---- Children --------------------------------------------------------------
. local lbl_child_skip_meals      "Child skipped meals [=1]"
r; t=0.00 13:03:33

. local lbl_child_vaccinated      "Child vaccinated [=1]"
r; t=0.00 13:03:33

. local lbl_child_worked          "Child worked [=1]"
r; t=0.00 13:03:33

. 
. * ---- Remittances -----------------------------------------------------------
. local lbl_index_remit           "Remittances index (SD)"
r; t=0.00 13:03:33

. local lbl_remit_now             "Sends remittances now [=1]"
r; t=0.00 13:03:33

. local lbl_remit_to_parents      "Remits to parents [=1]"
r; t=0.00 13:03:33

. 
. * ---- Financial access and digital ------------------------------------------
. local lbl_index_fin_access      "Financial access index (SD)"
r; t=0.00 13:03:33

. local lbl_index_digital         "Digital access index (SD)"
r; t=0.00 13:03:33

. local lbl_has_savings_account   "Has savings account [=1]"
r; t=0.00 13:03:33

. local lbl_has_mobile_money      "Has mobile money [=1]"
r; t=0.00 13:03:33

. local lbl_has_smartphone        "Has smartphone [=1]"
r; t=0.00 13:03:33

. local lbl_has_internet          "Has internet [=1]"
r; t=0.00 13:03:33

. local lbl_apps_whatsapp         "Uses WhatsApp [=1]"
r; t=0.00 13:03:33

. 
. * ============================================================================
. *  PREDETERMINED COVARIATES (used for balance tests and as RD controls)
. * ============================================================================
. 
. * ---- Demographics ----------------------------------------------------------
. local lbl_female                "Female [=1]"
r; t=0.00 13:03:33

. local lbl_age_panel             "Age (years)"
r; t=0.00 13:03:33

. local lbl_yrseduc               "Years of education"
r; t=0.00 13:03:33

. local lbl_time_col              "Years in Colombia"
r; t=0.00 13:03:33

. local lbl_child_venez           "Has child born in Venezuela [=1]"
r; t=0.00 13:03:33

. 
. * ---- Pre-migration economic conditions (in Venezuela) ----------------------
. local lbl_jobopp                "Had a job offer in Colombia [=1]"
r; t=0.00 13:03:33

. local lbl_labven                "Worked in Venezuela [=1]"
r; t=0.00 13:03:33

. local lbl_typeworkven1          "Worked in agric./manual (VZ) [=1]"
r; t=0.00 13:03:33

. local lbl_typeworkven2          "Worked in services (VZ) [=1]"
r; t=0.00 13:03:33

. local lbl_typeworkven3          "Worked in skilled occ. (VZ) [=1]"
r; t=0.00 13:03:33

. local lbl_written_cont          "Had written contract (VZ) [=1]"
r; t=0.00 13:03:33

. local lbl_average               "Avg. days worked / week (VZ)"
r; t=0.00 13:03:33

. local lbl_smartven              "Owned smartphone in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_owner                 "Homeowner in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_electven              "Had electricity in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_waterven              "Had running water in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_sewageven             "Had sewage in VZ [=1]"
r; t=0.00 13:03:33

. 
. * ---- Family / migration network -------------------------------------------
. local lbl_hhven_parents         "Parents born in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_hhven_spouse          "Spouse born in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_hhven_other           "Other HH members born in VZ [=1]"
r; t=0.00 13:03:33

. local lbl_healthmig             "Healthy at migration [=1]"
r; t=0.00 13:03:33

. local lbl_frdfam                "Network in Colombia [=1]"
r; t=0.00 13:03:33

. r; t=0.01 13:03:33

. 
. * JEEA-style sample
. use "$clean/PEP_Analysis_Sample.dta", clear
(PEP analysis sample (JEEA-style + extended outcome indices))
r; t=0.11 13:03:33

. local jeea_controls hhven_spouse hhven_other jobopp labven typeworkven1 ///
>                     typeworkven2 typeworkven3 written_cont average yrseduc ///
>                     healthmig frdfam smartven owner electven waterven ///
>                     sewageven female age_panel child_venez time_col
r; t=0.00 13:03:33

. gen sample_roster = .
(13,580 missing values generated)
r; t=0.00 13:03:33

. qui reg trt_hh `jeea_controls'
r; t=2.45 13:03:36

. replace sample_roster = e(sample)
(13,580 real changes made)
r; t=0.00 13:03:36

. replace sample_roster = 0 if gasto_capita == . & trt_hh != .
(119 real changes made)
r; t=0.00 13:03:36

. replace sample_roster = 0 if employed == . & trt_hh != .
(88 real changes made)
r; t=0.00 13:03:36

. replace sample_roster = 0 if hora_semana == . & trt_hh != . & asalariado_num == 1
(64 real changes made)
r; t=0.00 13:03:36

. replace sample_roster = 0 if anx_depr == .
(2 real changes made)
r; t=0.00 13:03:36

. replace sample_roster = 0 if health_pca == .
(8 real changes made)
r; t=0.00 13:03:36

. bysort family_id wave_num: egen sample_reg = max(sample_roster)
r; t=0.01 13:03:36

. keep if (orden == 1 | orden == 2) & sample_reg == 1
(6,604 observations deleted)
r; t=0.02 13:03:36

. 
. * Color palette (matches main figures)
. local W1col   "navy"
r; t=0.00 13:03:36

. local W2col   "cranberry"
r; t=0.00 13:03:36

. local W1fill  "navy%30"
r; t=0.00 13:03:36

. local W2fill  "cranberry%30"
r; t=0.00 13:03:36

. 
. * Helper to plot one histogram pair (W1 vs W2 overlaid)
. capture program drop _hist
r; t=0.00 13:03:36

. program define _hist
  1.     args var fname title xtitle xrange
  2.     twoway ///
>         (kdensity `var' if wave_num == 1, lcolor(`W1col') lwidth(medthick) lpattern(solid)) ///
>         (kdensity `var' if wave_num == 2, lcolor(`W2col') lwidth(medthick) lpattern(longdash)) ///
>         , title("`title'", size(medium) color(black)) ///
>           xtitle("`xtitle'", size(small)) ///
>           ytitle("Density", size(small)) ///
>           xlabel(`xrange', nogrid notick labsize(small)) ///
>           ylabel(, nogrid notick labsize(small)) ///
>           legend(order(1 "Wave 1 (2020)" 2 "Wave 2 (2021)") rows(1) ///
>                  position(6) ring(1) ///
>                  region(fcolor(white) lcolor(black) lwidth(thin) margin(small)) ///
>                  size(small) symxsize(*0.6) keygap(*1.0) colgap(*1.5)) ///
>           graphregion(color(white) margin(medium)) ///
>           plotregion(fcolor(white) lcolor(black) lwidth(thin) margin(small)) ///
>           bgcolor(white) ///
>           yscale(noline) xscale(noline) ///
>           name(`fname', replace)
  3.     graph export "${afig}/`fname'.pdf", replace
  4.     graph drop `fname'
  5. end
r; t=0.00 13:03:36

. 
. * Annual per-capita consumption: million COP at HH level (orden==1), trim 99th
. preserve
r; t=0.02 13:03:36

. qui sum gasto_capita_raw if orden == 1, d
r; t=0.01 13:03:36

. local cap99 = r(p99)
r; t=0.00 13:03:36

. keep if orden == 1 & gasto_capita_raw < `cap99'
(3,296 observations deleted)
r; t=0.01 13:03:36

. _hist gasto_capita_raw fig_hist_consumption ///
>     "Annual per-capita consumption" ///
>     "Per-capita consumption (million COP, annual)" ///
>     "0(2)20"
file ../outputs/appendix/figures/fig_hist_consumption.pdf saved as PDF format
r; t=2.36 13:03:38

. restore
r; t=0.01 13:03:38

. 
. * Monthly labor income (individual, working only)
. preserve
r; t=0.02 13:03:38

. qui sum labour_income_raw if labour_income_raw > 0, d
r; t=0.01 13:03:38

. local cap99 = r(p99)
r; t=0.00 13:03:38

. keep if labour_income_raw > 0 & labour_income_raw < `cap99'
(3,783 observations deleted)
r; t=0.01 13:03:38

. _hist labour_income_raw fig_hist_labor_income ///
>     "Monthly labor income (employed individuals)" ///
>     "Monthly labor income (COP)" ///
>     "0(500000)2500000"
file ../outputs/appendix/figures/fig_hist_labor_income.pdf saved as PDF format
r; t=1.19 13:03:40

. restore
r; t=0.01 13:03:40

. 
. * Age
. _hist age_panel fig_hist_age ///
>     "Age distribution" ///
>     "Age (years)" ///
>     "0(10)80"
file ../outputs/appendix/figures/fig_hist_age.pdf saved as PDF format
r; t=1.22 13:03:41

. 
. * Years of education (pre-migration)
. _hist yrseduc fig_hist_yrseduc ///
>     "Years of education at arrival" ///
>     "Years of education" ///
>     "0(2)20"
file ../outputs/appendix/figures/fig_hist_yrseduc.pdf saved as PDF format
r; t=1.27 13:03:42

. 
. * Time in Colombia at the time of the survey (months)
. _hist time_col fig_hist_time_col ///
>     "Time in Colombia at survey" ///
>     "Months in Colombia" ///
>     "0(12)96"
file ../outputs/appendix/figures/fig_hist_time_col.pdf saved as PDF format
r; t=1.27 13:03:43

. 
. di ""

r; t=0.00 13:03:43

. di "  Histograms saved to ${afig}/"
  Histograms saved to ../outputs/appendix/figures/
r; t=0.00 13:03:43

. 
. log close
      name:  <unnamed>
       log:  C:\Users\wb614536\Downloads\replication\replication\code\../outputs/14_DescHistograms_log.txt
  log type:  text
 closed on:  25 Jun 2026, 13:03:43
--------------------------------------------------------------------------------------------------------------------
